Scalar-valued Functions [dbo].[fn_asi_convert_foreign_string]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@instringvarchar(2000)2000
Permissions
TypeActionOwning Principal
GrantExecuteIMIS
SQL Script
/****** Object:  UserDefinedFunction dbo.fn_asi_convert_foreign_string  ******/
create function dbo.fn_asi_convert_foreign_string(@instring varchar(2000))
returns varchar(2000)
as
begin
     declare @i int
     declare @str_len int
     declare @outstring varchar(2000)
     set @str_len = len(@instring)
     set @i = 1
     set @outstring = ''
     while @i <= @str_len
     begin
         set @outstring = @outstring + dbo.fn_asi_convert_foreign_chars(substring(@instring,@i,1))
         set @i = @i + 1
     end
     return @outstring
end

GO
GRANT EXECUTE ON  [dbo].[fn_asi_convert_foreign_string] TO [IMIS]
GO
Uses
Used By